USE FB_DWCR;

exec sp_MSforeachtable @command1='USE FB_DWCR;  alter table dbo.[?] rebuild PARTITION = ALL with (DATA_COMPRESSION = ROW)'

alter table [dbo].[JDEABADDRESSBOOKWHOSWHO] rebuild PARTITION=ALL with (Data_COMPRESSION=ROW);



exec sp_MSforeachtable @command1='USE FB_DWCR;  alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = ROW)'
